CREATE TABLE [dbo].[vs_EstablecimientosEducativos]
(
[idOrganizacion] [int] NOT NULL,
[idSubOrganizacion] [int] NOT NULL,
[SubOrganizacion] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CUE] [int] NULL,
[CUI] [int] NULL,
[Denominacion] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domicilio] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Id_Localidad] [smallint] NOT NULL,
[CodigoPostal] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Localidad] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Id_Departamento] [int] NULL,
[Departamento] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Telefono] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ambito] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TipoAmbito] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Responsable] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CoordPedagógico] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Categoria] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Abreviatura] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Id_ORGCoordina] [int] NULL,
[Id_Tipo] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Estado] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Id_Dependencia] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tipo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Id_Nivel] [int] NULL,
[Nivel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Al_Nivel] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Id_Educacion] [int] NULL,
[Educacion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TipoEducacion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Id_TipoOrganizacion] [smallint] NULL,
[Id_TipoAmbito] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
